Phoenix - Your AI AssistantMacro 20photography Projects
Looking for freelance Macro 20photography jobs and project work? PeoplePerHour has you covered.
Help us build a excel app for a small family investment firm
Small family investment firm wants to build a tracker with reporting for managing Investments across several accounts. The work will be based in Excel, likely to need functions like the VLook-up, macros and possibly some VB plus report generation. It’s not likely to be a big piece of work - feels like a day of work really, paid hourly because it’s unclear. We have some of the tables mocked up with sample data in. Most of the work is about consolidating data from transaction logs into different views.
Part-time customer service and general admin
This role is focused on accuracy, consistency, and follow-through. It is not a sales role and not a creative role. It is for someone who enjoys structure, clear processes, and doing things properly every time. If you get bored easily, dislike repetition, or prefer to “do things your own way,” this role is not suitable. ⸻ What you’ll be responsible for You will be the front line of customer support and backend admin operations, including: • Managing customer enquiries via Gorgias (email and tickets) • Responding to customers using approved macros and brand tone • Processing returns, exchanges, replacements, and refunds • Managing the returns system end-to-end • Updating and managing orders inside Shopify • Creating replacement orders and handling order adjustments • Data entry and record updates • Tagging, categorising, and documenting issues correctly • Escalating issues appropriately when needed • Following customer service and admin SOPs exactly Accuracy, clarity, and consistency are critical in this role. ⸻ This role is ideal for someone who: • Communicates clearly, calmly, and professionally • Enjoys repetitive, process-driven work • Is highly detail-oriented and organised • Follows instructions and SOPs exactly • Works steadily and reliably without rushing • Can work independently once trained • Takes pride in doing things properly ⸻ This role is NOT suitable if you: • Get bored easily • Dislike repetitive tasks • Rush and fix mistakes later • Need constant supervision or reassurance • Like to improvise instead of following process • Struggle with accuracy or follow-through ⸻ Our standards (important) • Accuracy comes first • No guessing — ever • Follow processes exactly • Escalate rather than assume • Clear, respectful communication matters • One task at a time, done properly ⸻ Tools you’ll work with • Gorgias (customer service platform) • Shopify (orders, customers, admin) • Returns management systems • Google Workspace (Docs, Sheets, Gmail) Experience with these tools is helpful but not required if you are highly process-driven and willing to learn. ⸻ How to apply Please include: 1. A short paragraph explaining why this type of structured, repetitive work suits you 2. Your availability 3. Any experience you have with customer service platforms (if applicable) Applications that do not follow these instructions will not be considered.
Past "Macro photography" Projects
opportunity
Wayfair and Lowe’s Bulk Product Listing Specialist
The ideal candidate should have proven experience managing bulk product uploads and creating complex variant structures of Wayfair and Lowe’s online marketplaces. They must possess a strong command of Excel or Google Sheets, including the use of macros, advanced formulas, and data cleaning techniques, to ensure accuracy and efficiency in catalog management. A deep understanding of product attributes, technical specifications, and image mapping is essential to maintain data integrity and visual consistency. The role also requires fluent English and excellent communication skills to coordinate effectively across teams. Prior experience with Wayfair Partner Home is highly preferred. Key deliverables include the complete setup of product listings with accurate variants and attributes, precise image mapping for all SKUs, thoroughly validated data sheets ready for upload, and the preparation of weekly catalog performance and upload status reports. Apply only if you have hands-on experience uploading large bulk feed files for both Wayfair and Lowe’s, with a proven track record of successfully managing complex product data and variant structures. To be considered, you must provide a recent sample of a bulk upload feed file you have personally created for both Wayfair and Lowe’s. Also, share a situation where you faced a complex situation while uploading a large variant listing on Wayfair, and how you overcame that situation.
Create a macro
I hope you are well. Do you know how to create macros? I want to create a table of data with information about vehicles. The headings for this table can be found in Sheet2 of the attached spreadsheet. I would be pasting data into Sheet1 that I would want to be transferred to Sheet2. As you can see the data in Sheet1 would be pasted into a single column. I'd like a button that copies, pastes and transposes the data in Sheet1 into a table on Sheet2. Potentially there will be hundreds of rows in the table on Sheet2. I will be copying the data into Sheet1 from a website and it comes out in this single column format. So I would be overwriting the data in Sheet1 many times and would need it to add a new row to the table in Sheet2 every time I press the button. I hope my request makes sense. Is this possible? Many thanks, Jessica.
Fix a spreadsheet
I need help to fix an excel spreadsheet which has broken links and error; I don’t know if it is to do with the macros being broken I would need an opinion on that I can explain it better visually as I am not an exoert Thanks Margaret
Excel spreadsheet and formula specialist
I require an experienced Excel professional to help automate data manipulation and reporting across multiple spreadsheets for inventory and purchasing functions. Formulas will need to be devised to extract relevant information from the primary transactional spreadsheets tracking stock levels and orders, before compiling this data automatically into summary reports and dashboards. The core tasks will involve linking to and querying other workbooks to pull through the necessary values and fields on a regular basis. Knowledge of Excel's more sophisticated features such as Power Query, Power Pivot and macros will be advantageous for their transformation and aggregation capabilities. The aim is to minimise manual data transcriptions and provide live, interactive management reporting tools for inventory levels, purchasing trends, supplier lead times and other such measures. Applicants should have extensive hands-on experience designing and maintaining complex Excel solutions for clients, with proven skills in dissecting requirements, designing optimal formulas and presenting solutions in a clear manner.
Excel help - creating a macro or Vlook up to bring data together
Hello We have 4 datasheets in an Excel workbook. We keep contact data (name, company & email address) on there, each sheet has the contacts split into groups that they attend across the columns. There are probably c800 contacts across the sheets. Periodically I am looking search and bring together on a separate sheet all the contacts with a specific company email domain + the group they are each in - as I want to show that company which of their staff are involved in our groups. I would do this at a point in time. We are currently do this manually. So I am looking to have something set up on an extra sheet where I can specify which email domain I am looking for this time and then to 'run' it, and it will pick up the relevant contacts on each of the sheets and also the title of the group they are in. I am thinking perhaps a macro would work? See my fake data sheet. I am not looking to change the format/layout of the worksheets if possible, as we are all used to working with them as they are. Can you please quote for this work, I just put in a figure. I will share the actual spreadsheet with the freelancer once I have accepted your proposal. Many thanks Abby
opportunity
DCF model in 6 hours Friday next week at 2PM to 8 PM GST time
Please put together a one-page investment profile on the Company (as defined below) in PowerPoint format. Please put together a simple three-statement financial model of the Company in Excel which should include the following: Historical financial results of the Company for the last five years (2018-22) Projections for all three statements of the model for the next five years (2023-27) Valuation tab where you should calculate the fair share price of the Company by using DCF method and compare it with the current share price of the Company Assumptions tab where you should describe the key inputs and assumptions behind your projections / valuation, including any macro, operational and other datasets Your public Company for the above tasks is: Tesco plc. All the information on the Company should be sourced from the public sources only and the relevant links for your historical data inputs and for any assumptions you use should be included in the excel file together with the model.
opportunityurgent
I need this task to be completed within next 3 hour URGENT
Please put together a one-page investment profile on the Company (as defined below) in PowerPoint format. Please put together a simple three-statement financial model of the Company in Excel which should include the following: Historical financial results of the Company for the last five years (2018-22) Projections for all three statements of the model for the next five years (2023-27) Valuation tab where you should calculate the fair share price of the Company by using DCF method and compare it with the current share price of the Company Assumptions tab where you should describe the key inputs and assumptions behind your projections / valuation, including any macro, operational and other datasets Your public Company for the above tasks is: Tesco plc. All the information on the Company should be sourced from the public sources only and the relevant links for your historical data inputs and for any assumptions you use should be included in the excel file together with the model.
MACRO Expertise - To Identify and Populate CRM data as needed
We have 4 csv files. Each file has about 100000 records in it. Every record have bunch of company related information like name, phone, email, etc. There are a few records in those lists that don't have country mentioned in the COUNTRY column for them. So we want you to identify the ones that don't have any country mentioned, identify their country based on the dialing code of that record from the telephone number in the PHONE column. Is it something you can do?
Need rows cutting to columns (7,000 rows, but easily automated)
See attached spreadsheet for description but in short need rows converting to columns. It should be very easy with a macro.
Create excel finance tracker with Macros
Hi I am looking for an excel guru to create an excel spreadsheet with 4 tabs with macros in place. The spreadsheet should have a tab that calculates what I get paid, deducts all expenditure month by month. The 2nd tab does the same but is purely for debts, so the amount of debt outstanding per debtor, ,how much was paid per month, totals paid and totals left to pay. *with all tabs and columns I need to see cumulative totals The 3rd tab is for a small business - Income, expenses, totals, profit The 4th tab is for savings, paid in, taken out, totals after deduction if it helps, I have a template that needs tweaking as the formulas on some columns are not working
Small reformat changes to Word doc - table form this afternoon
Attached is the document. It needs a couple of small changes. a) to move names of the characters currently in a row above each speech / passage (M1:, M2:, W1:, W2: etc) into the adjacent column and next to the passage. b) to remove unnecessary blank rows - so that there is one empty row between speeches / passages as characters change but otherwise no blank rows. I have attached an example for the first two pages showing exactly what I mean. This is NOT a job for someone to change / copy out by hand. For someone who understands word well it should be a job of 5 minutes using search and replace and some sort of macro to make the changes. It is costed accordingly Please confirm that you can do this job this afternoon Monday
Macro enabled document
i need to create a document that is a report with a set of drop down options to complete the report and the edit/personalise the drop down options. word currently allows you to do this but it only gives the option to choose one of the drop down options at a time. there is also an initial section that is populated from a questionnaire this currently is hit and miss as to whether the information will populate and i would like this fixed or redone
pre-funded
Excel Automation and PowerBI Dashboards
I need automation of data in excel to provide forecasts and automate a single page view of each billed resource (within a master sheet). I have created the initial macro to split all resources from the master into multiple sheets of each resource. Now I require each of these sheets to be forecasted to provide visual data and over view.
opportunity
Excel template development
I need someone who is an advanced Excel expert (complex macros, etc) to develop an accounting spreadsheet, which can be easily edited by the end user to track a large volume of invoices in different currencies, convert currencies, split invoices etc I have a list of requirements which I can detail. For an excel expert I dont envisage this taking more than a few hours to complete.
Document formatting
We are in the process of completing a brand refresh and I am looking for someone to update our word documents (proposals, and a few internal docs). We already have formatting in place, I am just keen to standardise it and remove MACROs etc. Please only respond if you have experience in doing this. Looking for: Setup: margins, breaks, columns, headers, footers, orientation and page numbering. Structure: Mark-up parts, sections, headings and numbering schemes to determine document structure. Styling: Style headings, lists and numbering. Apply title casing, references, term and definition, footnotes. Tables: Create a consistent set of table styles to clearly present all different forms of data. And Table of Contents. We don't want MACROS - painful and not useful! We have three proposal documents, one internal memo document and one powerpoint document. If this works well, we will provide more work to include all HR and Events related documents.
opportunity
Excel Project - Data Analysis
I have a spreadsheet of data. i want the data formated using whatever you can - macro - vlookup - pivots... I will need an NDA signed as this is confidential data. This is all about deferred income and release of revenue, so if you are not aware of that process please do not apply for this. from the data i will need the following: Total invoice value by Client Billing protocol Contract details Monthly spread we are looking for an analysis monthly showing the opening balances, added in the month, jnls in the month, total residual. immediate start, i need this finished by 5pm Monday UK time. looking for Top cert Excel wizard.
Business Excel Calender
Excel expert to help tidy up existing business calendar, likely to be a 2 hour task. Calendar needs to filter different business departments but the links pulling the data together no longer exist or cannot be found. Macros and a general tidy up are needed to ensure all functions and calculations are formatted correctly and can be edited and managed by all end users. This should be a fairly easy task for someone with good excel skills. Deadline: Monday 24th January 2022 If you would like to discuss this further in detail, we would be happy to discuss on a zoom call
VBA assist with error on mac
I'm having a Compile error: User-defined type not defined the issue with a macro enable work sheet on mac.